﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ImportDataSet" targetNamespace="http://tempuri.org/ImportDataSet.xsd" xmlns:mstns="http://tempuri.org/ImportDataSet.xsd" xmlns="http://tempuri.org/ImportDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="nieuweprijzenConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="nieuweprijzenConnectionString (MySettings)" PropertyReference="ApplicationSettings.FairShop.My.MySettings.GlobalReference.Default.nieuweprijzenConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Blad1$TableAdapter" GeneratorDataComponentClassName="Blad1_TableAdapter" Name="Blad1$" UserDataComponentName="Blad1$TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nieuweprijzenConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Blad1$` (`ArtikelCode`, `ArtikelOmschrijving`, `Leverancier`, `Categorie`, `SubCategorie`, `Barcode`, `AantalPerVerpakking`, `AP Excl`, `AP Incl`, `VP Excl`, `VP Incl`, `BTW`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArtikelCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArtikelCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ArtikelOmschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ArtikelOmschrijving" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Leverancier" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Leverancier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Categorie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SubCategorie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SubCategorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Barcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AantalPerVerpakking" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AantalPerVerpakking" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AP_Excl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AP Excl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AP_Incl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AP Incl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="VP_Excl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VP Excl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="VP_Incl" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="VP Incl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BTW" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BTW" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ArtikelCode, ArtikelOmschrijving_NL, Leverancier, Categorie, SubCategorie, Barcode, [Aantal per verpakking], [AP Excl], [AP Incl], [VP Excl], [VP Incl], BTW FROM [Blad1$]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ArtikelCode" DataSetColumn="ArtikelCode" />
              <Mapping SourceColumn="ArtikelOmschrijving NL" DataSetColumn="ArtikelOmschrijving NL" />
              <Mapping SourceColumn="Leverancier" DataSetColumn="Leverancier" />
              <Mapping SourceColumn="Categorie" DataSetColumn="Categorie" />
              <Mapping SourceColumn="SubCategorie" DataSetColumn="SubCategorie" />
              <Mapping SourceColumn="Barcode" DataSetColumn="Barcode" />
              <Mapping SourceColumn="AantalPerVerpakking" DataSetColumn="Aantal per verpakking" />
              <Mapping SourceColumn="AP Excl" DataSetColumn="AP Excl" />
              <Mapping SourceColumn="AP Incl" DataSetColumn="AP Incl" />
              <Mapping SourceColumn="VP Excl" DataSetColumn="VP Excl" />
              <Mapping SourceColumn="VP Incl" DataSetColumn="VP Incl" />
              <Mapping SourceColumn="BTW" DataSetColumn="BTW" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ImportDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ImportDataSet" msprop:Generator_DataSetName="ImportDataSet" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Blad1_x0024_" msprop:Generator_UserTableName="Blad1$" msprop:Generator_RowDeletedName="_Blad1_RowDeleted" msprop:Generator_RowChangedName="_Blad1_RowChanged" msprop:Generator_RowClassName="_Blad1_Row" msprop:Generator_RowChangingName="_Blad1_RowChanging" msprop:Generator_RowEvArgName="_Blad1_RowChangeEvent" msprop:Generator_RowEvHandlerName="_Blad1_RowChangeEventHandler" msprop:Generator_TableClassName="_Blad1_DataTable" msprop:Generator_TableVarName="_tableBlad1_" msprop:Generator_RowDeletingName="_Blad1_RowDeleting" msprop:Generator_TablePropName="_Blad1_">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ArtikelCode" msprop:Generator_UserColumnName="ArtikelCode" msprop:Generator_ColumnPropNameInRow="ArtikelCode" msprop:Generator_ColumnVarNameInTable="columnArtikelCode" msprop:Generator_ColumnPropNameInTable="ArtikelCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArtikelOmschrijving_x0020_NL" msprop:Generator_UserColumnName="ArtikelOmschrijving NL" msprop:Generator_ColumnPropNameInRow="ArtikelOmschrijving_NL" msprop:Generator_ColumnVarNameInTable="columnArtikelOmschrijving_NL" msprop:Generator_ColumnPropNameInTable="ArtikelOmschrijving_NLColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="82" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Leverancier" msprop:Generator_UserColumnName="Leverancier" msprop:Generator_ColumnPropNameInRow="Leverancier" msprop:Generator_ColumnVarNameInTable="columnLeverancier" msprop:Generator_ColumnPropNameInTable="LeverancierColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Categorie" msprop:Generator_UserColumnName="Categorie" msprop:Generator_ColumnPropNameInRow="Categorie" msprop:Generator_ColumnVarNameInTable="columnCategorie" msprop:Generator_ColumnPropNameInTable="CategorieColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SubCategorie" msprop:Generator_UserColumnName="SubCategorie" msprop:Generator_ColumnPropNameInRow="SubCategorie" msprop:Generator_ColumnVarNameInTable="columnSubCategorie" msprop:Generator_ColumnPropNameInTable="SubCategorieColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Barcode" msprop:Generator_UserColumnName="Barcode" msprop:Generator_ColumnPropNameInRow="Barcode" msprop:Generator_ColumnVarNameInTable="columnBarcode" msprop:Generator_ColumnPropNameInTable="BarcodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Aantal_x0020_per_x0020_verpakking" msprop:Generator_UserColumnName="Aantal per verpakking" msprop:Generator_ColumnPropNameInRow="Aantal_per_verpakking" msprop:Generator_ColumnVarNameInTable="columnAantal_per_verpakking" msprop:Generator_ColumnPropNameInTable="Aantal_per_verpakkingColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AP_x0020_Excl" msprop:Generator_UserColumnName="AP Excl" msprop:Generator_ColumnPropNameInRow="AP_Excl" msprop:Generator_ColumnVarNameInTable="columnAP_Excl" msprop:Generator_ColumnPropNameInTable="AP_ExclColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AP_x0020_Incl" msprop:Generator_UserColumnName="AP Incl" msprop:Generator_ColumnPropNameInRow="AP_Incl" msprop:Generator_ColumnVarNameInTable="columnAP_Incl" msprop:Generator_ColumnPropNameInTable="AP_InclColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VP_x0020_Excl" msprop:Generator_UserColumnName="VP Excl" msprop:Generator_ColumnPropNameInRow="VP_Excl" msprop:Generator_ColumnVarNameInTable="columnVP_Excl" msprop:Generator_ColumnPropNameInTable="VP_ExclColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VP_x0020_Incl" msprop:Generator_UserColumnName="VP Incl" msprop:Generator_ColumnPropNameInRow="VP_Incl" msprop:Generator_ColumnVarNameInTable="columnVP_Incl" msprop:Generator_ColumnPropNameInTable="VP_InclColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BTW" msprop:Generator_UserColumnName="BTW" msprop:Generator_ColumnPropNameInRow="BTW" msprop:Generator_ColumnVarNameInTable="columnBTW" msprop:Generator_ColumnPropNameInTable="BTWColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>